select * from products where pro_name like '%all%dresses%' or pro_des like '%all%dresses%'union all select * from products where (pro_name like '%all%' or pro_des like '%all%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%all%dresses%' or pro_des not like '%all%dresses%')
Dignified Rhinestone DreamlikeJewelry Set Including Necklace Tiara
Star Shaped Shining Rhinestones Alloy Wedding Jewelry Set Including Necklace And Earrings
Splendid Alloy With Rhinestone Pearl Ladies Jewelry Sets
Intensive Flower Dazzling Crystal Jewelry Set Including Necklace And Tiara
Multi-colored Alloy With Rhinestone Ladies Jewelry Sets
Pretty Alloy Ladies Jewelry Sets
Round shaped Rotary Crystal Jewelry Set Including Necklace And Headpiece
Luxurious Alloy With Rhinestone Crystal Ladies Jewelry Sets
Mysterious Alloy Pearl Rhinestone Ladies Jewelry Sets
Beautiful Alloy With Rhinestone Ladies Jewelry Sets
Vintage Style Rhinestons Necklace And Crown With Shining Diamond
Dreamlike Artistic Crystal Necklace Bracele And Hair Bowknot
Shining Alloy With Rhinestone Ladies Jewelry Sets
Elegant Alloy With Cubic Zirconia Ladies Jewelry Sets
Exquisite Alloy With Rhinestone Pearl Ladies Jewelry Sets
Dreamlike Alloy With Rhinestone Pearl Ladies Jewelry Sets
Elegant Alloy With Cubic Zirconia Ladies Jewelry Sets
Fabulous Rhinestone With Alloy Ladies Jewelry Sets
Dazzling Alloy Jewelry Set Necklace And Headpiece
Splendid Rhinestone and Alloy Dignified Jewelry Set
Shimmering Alloy And Imitation Pearl Necklace
Gorgeous Dazzling Rhinestone Jewelry Set Necklace And Headflower
Rhinestone Dignified Necklace And Tiara
Gorgeous Dazzling Rhinestone Jewelry Set Necklace And Tiara
High Quality Alloy With Crystal Ladies Tiara and Necklace
Wedding Jewelry Set Including Necklace And Headpiece
Romantic Rhinestone Jewelry Set Including Tiara Necklace And Earrings
Multi Color Crystal Round Shaped Jewelry Set Including Necklace And Headpiece
Intensive Flowers Beaded Necklace Tiara and Earrings Jewelry Set
Blue Crystal Round Shaped Jewelry Set Including Necklace And Headflower